Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 601866 |
| Missing cells | 2866841 |
| Missing cells (%) | 15.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 142.3 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| Categorical | 5 |
| Text | 6 |
CANCELLED is highly imbalanced (83.5%) | Imbalance |
DIVERTED is highly imbalanced (96.5%) | Imbalance |
DEP_TIME has 13965 (2.3%) missing values | Missing |
DEP_DELAY has 13979 (2.3%) missing values | Missing |
TAXI_OUT has 14563 (2.4%) missing values | Missing |
TAXI_IN has 14764 (2.5%) missing values | Missing |
ARR_TIME has 14764 (2.5%) missing values | Missing |
ARR_DELAY has 16808 (2.8%) missing values | Missing |
CANCELLATION_CODE has 587260 (97.6%) missing values | Missing |
AIR_TIME has 16808 (2.8%) missing values | Missing |
CARRIER_DELAY has 434786 (72.2%) missing values | Missing |
WEATHER_DELAY has 434786 (72.2%) missing values | Missing |
NAS_DELAY has 434786 (72.2%) missing values | Missing |
SECURITY_DELAY has 434786 (72.2%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 434786 (72.2%) missing values | Missing |
SECURITY_DELAY is highly skewed (γ1 = 86.50351659) | Skewed |
DEP_DELAY has 27047 (4.5%) zeros | Zeros |
ARR_DELAY has 10416 (1.7%) zeros | Zeros |
CARRIER_DELAY has 70641 (11.7%) zeros | Zeros |
WEATHER_DELAY has 155236 (25.8%) zeros | Zeros |
NAS_DELAY has 90483 (15.0%) zeros | Zeros |
SECURITY_DELAY has 166287 (27.6%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 72648 (12.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 06:04:19.192239 |
|---|---|
| Analysis finished | 2024-03-30 06:07:14.050459 |
| Duration | 2 minutes and 54.86 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0514733 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.0744099 |
|---|---|
| Coefficient of variation (CV) | 0.51201373 |
| Kurtosis | -1.3152161 |
| Mean | 4.0514733 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.05710063 |
| Sum | 2438444 |
| Variance | 4.3031766 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 1 | 99253 | |
| 7 | 97766 | |
| 6 | 90575 | |
| 4 | 80967 | |
| 5 | 80923 | |
| 3 | 78132 | |
| 2 | 74250 |
| Value | Count | Frequency (%) |
| 1 | 99253 | |
| 2 | 74250 | |
| 3 | 78132 | |
| 4 | 80967 | |
| 5 | 80923 | |
| 6 | 90575 | |
| 7 | 97766 |
| Value | Count | Frequency (%) |
| 7 | 97766 | |
| 6 | 90575 | |
| 5 | 80923 | |
| 4 | 80967 | |
| 3 | 78132 | |
| 2 | 74250 | |
| 1 | 99253 |
FL_DATE
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| 7/27/2023 12:00:00 AM | 20464 |
|---|---|
| 7/20/2023 12:00:00 AM | 20461 |
| 7/21/2023 12:00:00 AM | 20459 |
| 7/28/2023 12:00:00 AM | 20444 |
| 7/24/2023 12:00:00 AM | 20443 |
| Other values (26) |
Length
| Max length | 21 |
|---|---|
| Median length | 21 |
| Mean length | 20.723372 |
| Min length | 20 |
Characters and Unicode
| Total characters | 12472693 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 7/3/2023 12:00:00 AM |
|---|---|
| 2nd row | 7/3/2023 12:00:00 AM |
| 3rd row | 7/3/2023 12:00:00 AM |
| 4th row | 7/3/2023 12:00:00 AM |
| 5th row | 7/3/2023 12:00:00 AM |
Common Values
| Value | Count | Frequency (%) |
| 7/27/2023 12:00:00 AM | 20464 | 3.4% |
| 7/20/2023 12:00:00 AM | 20461 | 3.4% |
| 7/21/2023 12:00:00 AM | 20459 | 3.4% |
| 7/28/2023 12:00:00 AM | 20444 | 3.4% |
| 7/24/2023 12:00:00 AM | 20443 | 3.4% |
| 7/17/2023 12:00:00 AM | 20439 | 3.4% |
| 7/13/2023 12:00:00 AM | 20426 | 3.4% |
| 7/14/2023 12:00:00 AM | 20422 | 3.4% |
| 7/31/2023 12:00:00 AM | 20420 | 3.4% |
| 7/10/2023 12:00:00 AM | 20282 | 3.4% |
| Other values (21) | 397606 |
Length
| Value | Count | Frequency (%) |
| 12:00:00 | 601866 | |
| am | 601866 | |
| 7/27/2023 | 20464 | 1.1% |
| 7/20/2023 | 20461 | 1.1% |
| 7/21/2023 | 20459 | 1.1% |
| 7/28/2023 | 20444 | 1.1% |
| 7/24/2023 | 20443 | 1.1% |
| 7/17/2023 | 20439 | 1.1% |
| 7/13/2023 | 20426 | 1.1% |
| 7/14/2023 | 20422 | 1.1% |
| Other values (23) | 438308 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3069956 | |
| 2 | 2059635 | |
| / | 1203732 | 9.7% |
| 1203732 | 9.7% | |
| : | 1203732 | 9.7% |
| 1 | 877046 | 7.0% |
| 3 | 700158 | 5.6% |
| 7 | 662367 | 5.3% |
| A | 601866 | 4.8% |
| M | 601866 | 4.8% |
| Other values (5) | 288603 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12472693 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3069956 | |
| 2 | 2059635 | |
| / | 1203732 | 9.7% |
| 1203732 | 9.7% | |
| : | 1203732 | 9.7% |
| 1 | 877046 | 7.0% |
| 3 | 700158 | 5.6% |
| 7 | 662367 | 5.3% |
| A | 601866 | 4.8% |
| M | 601866 | 4.8% |
| Other values (5) | 288603 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12472693 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3069956 | |
| 2 | 2059635 | |
| / | 1203732 | 9.7% |
| 1203732 | 9.7% | |
| : | 1203732 | 9.7% |
| 1 | 877046 | 7.0% |
| 3 | 700158 | 5.6% |
| 7 | 662367 | 5.3% |
| A | 601866 | 4.8% |
| M | 601866 | 4.8% |
| Other values (5) | 288603 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12472693 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3069956 | |
| 2 | 2059635 | |
| / | 1203732 | 9.7% |
| 1203732 | 9.7% | |
| : | 1203732 | 9.7% |
| 1 | 877046 | 7.0% |
| 3 | 700158 | 5.6% |
| 7 | 662367 | 5.3% |
| A | 601866 | 4.8% |
| M | 601866 | 4.8% |
| Other values (5) | 288603 | 2.3% |
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1203732 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 126469 | |
| DL | 89751 | |
| AA | 83013 | |
| UA | 65002 | |
| OO | 57287 | |
| YX | 25385 | 4.2% |
| B6 | 22853 | 3.8% |
| AS | 22743 | 3.8% |
| NK | 21187 | 3.5% |
| MQ | 19526 | 3.2% |
| Other values (5) | 68650 |
Length
| Value | Count | Frequency (%) |
| wn | 126469 | |
| dl | 89751 | |
| aa | 83013 | |
| ua | 65002 | |
| oo | 57287 | |
| yx | 25385 | 4.2% |
| b6 | 22853 | 3.8% |
| as | 22743 | 3.8% |
| nk | 21187 | 3.5% |
| mq | 19526 | 3.2% |
| Other values (5) | 68650 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 260856 | |
| N | 147656 | |
| O | 131514 | |
| W | 126469 | |
| D | 89751 | 7.5% |
| L | 89751 | 7.5% |
| U | 65002 | 5.4% |
| 9 | 32444 | 2.7% |
| Y | 25385 | 2.1% |
| X | 25385 | 2.1% |
| Other values (11) | 209519 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1203732 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 260856 | |
| N | 147656 | |
| O | 131514 | |
| W | 126469 | |
| D | 89751 | 7.5% |
| L | 89751 | 7.5% |
| U | 65002 | 5.4% |
| 9 | 32444 | 2.7% |
| Y | 25385 | 2.1% |
| X | 25385 | 2.1% |
| Other values (11) | 209519 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1203732 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 260856 | |
| N | 147656 | |
| O | 131514 | |
| W | 126469 | |
| D | 89751 | 7.5% |
| L | 89751 | 7.5% |
| U | 65002 | 5.4% |
| 9 | 32444 | 2.7% |
| Y | 25385 | 2.1% |
| X | 25385 | 2.1% |
| Other values (11) | 209519 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1203732 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 260856 | |
| N | 147656 | |
| O | 131514 | |
| W | 126469 | |
| D | 89751 | 7.5% |
| L | 89751 | 7.5% |
| U | 65002 | 5.4% |
| 9 | 32444 | 2.7% |
| Y | 25385 | 2.1% |
| X | 25385 | 2.1% |
| Other values (11) | 209519 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5923 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2309.749 |
| Minimum | 1 |
|---|---|
| Maximum | 8819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 278 |
| Q1 | 1037 |
| median | 2079 |
| Q3 | 3347 |
| 95-th percentile | 5380 |
| Maximum | 8819 |
| Range | 8818 |
| Interquartile range (IQR) | 2310 |
Descriptive statistics
| Standard deviation | 1567.6158 |
|---|---|
| Coefficient of variation (CV) | 0.67869531 |
| Kurtosis | -0.59900956 |
| Mean | 2309.749 |
| Median Absolute Deviation (MAD) | 1118 |
| Skewness | 0.59042832 |
| Sum | 1.3901594 × 109 |
| Variance | 2457419.4 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1150 | 336 | 0.1% |
| 358 | 328 | 0.1% |
| 312 | 308 | 0.1% |
| 323 | 307 | 0.1% |
| 374 | 302 | 0.1% |
| 777 | 301 | 0.1% |
| 555 | 299 | < 0.1% |
| 573 | 298 | < 0.1% |
| 512 | 287 | < 0.1% |
| 354 | 283 | < 0.1% |
| Other values (5913) | 598817 |
| Value | Count | Frequency (%) |
| 1 | 198 | |
| 2 | 187 | |
| 3 | 133 | |
| 4 | 168 | |
| 5 | 106 | |
| 6 | 89 | |
| 7 | 177 | |
| 8 | 121 | |
| 9 | 173 | |
| 10 | 195 |
| Value | Count | Frequency (%) |
| 8819 | 1 | < 0.1% |
| 8817 | 1 | < 0.1% |
| 8810 | 1 | < 0.1% |
| 8801 | 1 | < 0.1% |
| 8800 | 1 | < 0.1% |
| 8799 | 1 | < 0.1% |
| 8788 | 1 | < 0.1% |
| 8786 | 1 | < 0.1% |
| 8785 | 1 | < 0.1% |
| 8784 | 4 |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 336 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12646.706 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1535.8975 |
|---|---|
| Coefficient of variation (CV) | 0.12144644 |
| Kurtosis | -1.3043379 |
| Mean | 12646.706 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.10825307 |
| Sum | 7.6116226 × 109 |
| Variance | 2358981 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 29919 | 5.0% |
| 11298 | 26010 | 4.3% |
| 11292 | 25684 | 4.3% |
| 13930 | 22796 | 3.8% |
| 12892 | 17523 | 2.9% |
| 11057 | 16976 | 2.8% |
| 12889 | 15879 | 2.6% |
| 14747 | 15666 | 2.6% |
| 14107 | 14037 | 2.3% |
| 13204 | 13770 | 2.3% |
| Other values (326) | 403606 |
| Value | Count | Frequency (%) |
| 10135 | 422 | 0.1% |
| 10136 | 119 | < 0.1% |
| 10140 | 2044 | |
| 10141 | 62 | < 0.1% |
| 10146 | 62 | < 0.1% |
| 10154 | 436 | 0.1% |
| 10155 | 92 | < 0.1% |
| 10157 | 145 | < 0.1% |
| 10158 | 213 | < 0.1% |
| 10165 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 142 | < 0.1% |
| 16218 | 146 | < 0.1% |
| 15991 | 62 | < 0.1% |
| 15919 | 1048 | |
| 15897 | 64 | < 0.1% |
| 15841 | 62 | < 0.1% |
| 15624 | 1099 | |
| 15607 | 62 | < 0.1% |
| 15582 | 53 | < 0.1% |
| 15569 | 53 | < 0.1% |
ORIGIN
Text
| Distinct | 336 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1805598 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CLT |
|---|---|
| 2nd row | JFK |
| 3rd row | SYR |
| 4th row | BGR |
| 5th row | LGA |
| Value | Count | Frequency (%) |
| atl | 29919 | 5.0% |
| dfw | 26010 | 4.3% |
| den | 25684 | 4.3% |
| ord | 22796 | 3.8% |
| lax | 17523 | 2.9% |
| clt | 16976 | 2.8% |
| las | 15879 | 2.6% |
| sea | 15666 | 2.6% |
| phx | 14037 | 2.3% |
| mco | 13770 | 2.3% |
| Other values (326) | 403606 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 206051 | 11.4% |
| L | 164641 | 9.1% |
| S | 154663 | 8.6% |
| D | 142889 | 7.9% |
| T | 95535 | 5.3% |
| O | 92161 | 5.1% |
| C | 91838 | 5.1% |
| M | 81874 | 4.5% |
| F | 75314 | 4.2% |
| W | 71042 | 3.9% |
| Other values (16) | 629590 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 206051 | 11.4% |
| L | 164641 | 9.1% |
| S | 154663 | 8.6% |
| D | 142889 | 7.9% |
| T | 95535 | 5.3% |
| O | 92161 | 5.1% |
| C | 91838 | 5.1% |
| M | 81874 | 4.5% |
| F | 75314 | 4.2% |
| W | 71042 | 3.9% |
| Other values (16) | 629590 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 206051 | 11.4% |
| L | 164641 | 9.1% |
| S | 154663 | 8.6% |
| D | 142889 | 7.9% |
| T | 95535 | 5.3% |
| O | 92161 | 5.1% |
| C | 91838 | 5.1% |
| M | 81874 | 4.5% |
| F | 75314 | 4.2% |
| W | 71042 | 3.9% |
| Other values (16) | 629590 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 206051 | 11.4% |
| L | 164641 | 9.1% |
| S | 154663 | 8.6% |
| D | 142889 | 7.9% |
| T | 95535 | 5.3% |
| O | 92161 | 5.1% |
| C | 91838 | 5.1% |
| M | 81874 | 4.5% |
| F | 75314 | 4.2% |
| W | 71042 | 3.9% |
| Other values (16) | 629590 |
ORIGIN_CITY_NAME
Text
| Distinct | 330 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.055089 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7857414 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Charlotte, NC |
|---|---|
| 2nd row | New York, NY |
| 3rd row | Syracuse, NY |
| 4th row | Bangor, ME |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 65123 | 4.7% |
| tx | 64035 | 4.6% |
| fl | 50480 | 3.6% |
| san | 32137 | 2.3% |
| ga | 32108 | 2.3% |
| il | 31893 | 2.3% |
| ny | 31272 | 2.2% |
| chicago | 30738 | 2.2% |
| atlanta | 29919 | 2.1% |
| new | 28622 | 2.0% |
| Other values (401) | 1003804 |
Most occurring characters
| Value | Count | Frequency (%) |
| 798265 | 10.2% | |
| a | 602550 | 7.7% |
| , | 601866 | 7.7% |
| o | 431943 | 5.5% |
| e | 413987 | 5.3% |
| n | 386586 | 4.9% |
| t | 378533 | 4.8% |
| l | 351400 | 4.5% |
| i | 299598 | 3.8% |
| r | 282936 | 3.6% |
| Other values (47) | 3309750 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7857414 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 798265 | 10.2% | |
| a | 602550 | 7.7% |
| , | 601866 | 7.7% |
| o | 431943 | 5.5% |
| e | 413987 | 5.3% |
| n | 386586 | 4.9% |
| t | 378533 | 4.8% |
| l | 351400 | 4.5% |
| i | 299598 | 3.8% |
| r | 282936 | 3.6% |
| Other values (47) | 3309750 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7857414 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 798265 | 10.2% | |
| a | 602550 | 7.7% |
| , | 601866 | 7.7% |
| o | 431943 | 5.5% |
| e | 413987 | 5.3% |
| n | 386586 | 4.9% |
| t | 378533 | 4.8% |
| l | 351400 | 4.5% |
| i | 299598 | 3.8% |
| r | 282936 | 3.6% |
| Other values (47) | 3309750 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7857414 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 798265 | 10.2% | |
| a | 602550 | 7.7% |
| , | 601866 | 7.7% |
| o | 431943 | 5.5% |
| e | 413987 | 5.3% |
| n | 386586 | 4.9% |
| t | 378533 | 4.8% |
| l | 351400 | 4.5% |
| i | 299598 | 3.8% |
| r | 282936 | 3.6% |
| Other values (47) | 3309750 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1731332 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4919131 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | North Carolina |
|---|---|
| 2nd row | New York |
| 3rd row | New York |
| 4th row | Maine |
| 5th row | New York |
| Value | Count | Frequency (%) |
| california | 65123 | 9.5% |
| texas | 64035 | 9.3% |
| florida | 50480 | 7.3% |
| new | 46208 | 6.7% |
| georgia | 32108 | 4.7% |
| illinois | 31893 | 4.6% |
| carolina | 31582 | 4.6% |
| york | 31272 | 4.5% |
| colorado | 28486 | 4.1% |
| north | 26955 | 3.9% |
| Other values (51) | 280852 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 662442 | |
| i | 552226 | 11.2% |
| o | 471161 | 9.6% |
| n | 367257 | 7.5% |
| r | 351547 | 7.1% |
| e | 300267 | 6.1% |
| s | 284743 | 5.8% |
| l | 273195 | 5.6% |
| C | 126966 | 2.6% |
| t | 120110 | 2.4% |
| Other values (37) | 1409217 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4919131 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 662442 | |
| i | 552226 | 11.2% |
| o | 471161 | 9.6% |
| n | 367257 | 7.5% |
| r | 351547 | 7.1% |
| e | 300267 | 6.1% |
| s | 284743 | 5.8% |
| l | 273195 | 5.6% |
| C | 126966 | 2.6% |
| t | 120110 | 2.4% |
| Other values (37) | 1409217 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4919131 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 662442 | |
| i | 552226 | 11.2% |
| o | 471161 | 9.6% |
| n | 367257 | 7.5% |
| r | 351547 | 7.1% |
| e | 300267 | 6.1% |
| s | 284743 | 5.8% |
| l | 273195 | 5.6% |
| C | 126966 | 2.6% |
| t | 120110 | 2.4% |
| Other values (37) | 1409217 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4919131 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 662442 | |
| i | 552226 | 11.2% |
| o | 471161 | 9.6% |
| n | 367257 | 7.5% |
| r | 351547 | 7.1% |
| e | 300267 | 6.1% |
| s | 284743 | 5.8% |
| l | 273195 | 5.6% |
| C | 126966 | 2.6% |
| t | 120110 | 2.4% |
| Other values (37) | 1409217 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.569446 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 45 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.901122 |
|---|---|
| Coefficient of variation (CV) | 0.49297041 |
| Kurtosis | -1.3034784 |
| Mean | 54.569446 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.041310785 |
| Sum | 32843494 |
| Variance | 723.67038 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91 | 65123 | 10.8% |
| 74 | 64035 | 10.6% |
| 33 | 50480 | 8.4% |
| 34 | 32108 | 5.3% |
| 41 | 31893 | 5.3% |
| 22 | 31272 | 5.2% |
| 82 | 28486 | 4.7% |
| 36 | 25534 | 4.2% |
| 38 | 20312 | 3.4% |
| 93 | 17896 | 3.0% |
| Other values (42) | 234727 |
| Value | Count | Frequency (%) |
| 1 | 4083 | 0.7% |
| 2 | 11827 | |
| 3 | 3635 | 0.6% |
| 4 | 518 | 0.1% |
| 5 | 124 | < 0.1% |
| 11 | 1775 | 0.3% |
| 12 | 1738 | 0.3% |
| 13 | 13090 | |
| 14 | 628 | 0.1% |
| 15 | 1207 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 17896 | 3.0% |
| 92 | 6840 | 1.1% |
| 91 | 65123 | |
| 88 | 967 | 0.2% |
| 87 | 10166 | 1.7% |
| 86 | 2260 | 0.4% |
| 85 | 17741 | 2.9% |
| 84 | 2815 | 0.5% |
| 83 | 2388 | 0.4% |
| 82 | 28486 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 336 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12646.664 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1535.9055 |
|---|---|
| Coefficient of variation (CV) | 0.12144748 |
| Kurtosis | -1.3043528 |
| Mean | 12646.664 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.10831242 |
| Sum | 7.6115971 × 109 |
| Variance | 2359005.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 29915 | 5.0% |
| 11298 | 26009 | 4.3% |
| 11292 | 25681 | 4.3% |
| 13930 | 22788 | 3.8% |
| 12892 | 17518 | 2.9% |
| 11057 | 16981 | 2.8% |
| 12889 | 15880 | 2.6% |
| 14747 | 15672 | 2.6% |
| 14107 | 14032 | 2.3% |
| 13204 | 13772 | 2.3% |
| Other values (326) | 403618 |
| Value | Count | Frequency (%) |
| 10135 | 422 | 0.1% |
| 10136 | 119 | < 0.1% |
| 10140 | 2043 | |
| 10141 | 62 | < 0.1% |
| 10146 | 62 | < 0.1% |
| 10154 | 436 | 0.1% |
| 10155 | 92 | < 0.1% |
| 10157 | 145 | < 0.1% |
| 10158 | 213 | < 0.1% |
| 10165 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 142 | < 0.1% |
| 16218 | 146 | < 0.1% |
| 15991 | 62 | < 0.1% |
| 15919 | 1048 | |
| 15897 | 64 | < 0.1% |
| 15841 | 62 | < 0.1% |
| 15624 | 1098 | |
| 15607 | 62 | < 0.1% |
| 15582 | 53 | < 0.1% |
| 15569 | 53 | < 0.1% |
DEST
Text
| Distinct | 336 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1805598 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | JFK |
|---|---|
| 2nd row | CLT |
| 3rd row | DTW |
| 4th row | LGA |
| 5th row | BGR |
| Value | Count | Frequency (%) |
| atl | 29915 | 5.0% |
| dfw | 26009 | 4.3% |
| den | 25681 | 4.3% |
| ord | 22788 | 3.8% |
| lax | 17518 | 2.9% |
| clt | 16981 | 2.8% |
| las | 15880 | 2.6% |
| sea | 15672 | 2.6% |
| phx | 14032 | 2.3% |
| mco | 13772 | 2.3% |
| Other values (326) | 403618 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 206053 | 11.4% |
| L | 164643 | 9.1% |
| S | 154673 | 8.6% |
| D | 142874 | 7.9% |
| T | 95543 | 5.3% |
| O | 92158 | 5.1% |
| C | 91854 | 5.1% |
| M | 81878 | 4.5% |
| F | 75303 | 4.2% |
| W | 71037 | 3.9% |
| Other values (16) | 629582 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 206053 | 11.4% |
| L | 164643 | 9.1% |
| S | 154673 | 8.6% |
| D | 142874 | 7.9% |
| T | 95543 | 5.3% |
| O | 92158 | 5.1% |
| C | 91854 | 5.1% |
| M | 81878 | 4.5% |
| F | 75303 | 4.2% |
| W | 71037 | 3.9% |
| Other values (16) | 629582 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 206053 | 11.4% |
| L | 164643 | 9.1% |
| S | 154673 | 8.6% |
| D | 142874 | 7.9% |
| T | 95543 | 5.3% |
| O | 92158 | 5.1% |
| C | 91854 | 5.1% |
| M | 81878 | 4.5% |
| F | 75303 | 4.2% |
| W | 71037 | 3.9% |
| Other values (16) | 629582 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 206053 | 11.4% |
| L | 164643 | 9.1% |
| S | 154673 | 8.6% |
| D | 142874 | 7.9% |
| T | 95543 | 5.3% |
| O | 92158 | 5.1% |
| C | 91854 | 5.1% |
| M | 81878 | 4.5% |
| F | 75303 | 4.2% |
| W | 71037 | 3.9% |
| Other values (16) | 629582 |
DEST_CITY_NAME
Text
| Distinct | 330 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.054918 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7857311 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | Charlotte, NC |
| 3rd row | Detroit, MI |
| 4th row | New York, NY |
| 5th row | Bangor, ME |
| Value | Count | Frequency (%) |
| ca | 65121 | 4.7% |
| tx | 64030 | 4.6% |
| fl | 50480 | 3.6% |
| san | 32129 | 2.3% |
| ga | 32103 | 2.3% |
| il | 31881 | 2.3% |
| ny | 31276 | 2.2% |
| chicago | 30726 | 2.2% |
| atlanta | 29915 | 2.1% |
| new | 28624 | 2.0% |
| Other values (401) | 1003830 |
Most occurring characters
| Value | Count | Frequency (%) |
| 798249 | 10.2% | |
| a | 602548 | 7.7% |
| , | 601866 | 7.7% |
| o | 431941 | 5.5% |
| e | 413987 | 5.3% |
| n | 386583 | 4.9% |
| t | 378537 | 4.8% |
| l | 351422 | 4.5% |
| i | 299565 | 3.8% |
| r | 282937 | 3.6% |
| Other values (47) | 3309676 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7857311 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 798249 | 10.2% | |
| a | 602548 | 7.7% |
| , | 601866 | 7.7% |
| o | 431941 | 5.5% |
| e | 413987 | 5.3% |
| n | 386583 | 4.9% |
| t | 378537 | 4.8% |
| l | 351422 | 4.5% |
| i | 299565 | 3.8% |
| r | 282937 | 3.6% |
| Other values (47) | 3309676 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7857311 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 798249 | 10.2% | |
| a | 602548 | 7.7% |
| , | 601866 | 7.7% |
| o | 431941 | 5.5% |
| e | 413987 | 5.3% |
| n | 386583 | 4.9% |
| t | 378537 | 4.8% |
| l | 351422 | 4.5% |
| i | 299565 | 3.8% |
| r | 282937 | 3.6% |
| Other values (47) | 3309676 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7857311 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 798249 | 10.2% | |
| a | 602548 | 7.7% |
| , | 601866 | 7.7% |
| o | 431941 | 5.5% |
| e | 413987 | 5.3% |
| n | 386583 | 4.9% |
| t | 378537 | 4.8% |
| l | 351422 | 4.5% |
| i | 299565 | 3.8% |
| r | 282937 | 3.6% |
| Other values (47) | 3309676 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1732512 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4919202 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | North Carolina |
| 3rd row | Michigan |
| 4th row | New York |
| 5th row | Maine |
| Value | Count | Frequency (%) |
| california | 65121 | 9.5% |
| texas | 64030 | 9.3% |
| florida | 50480 | 7.3% |
| new | 46216 | 6.7% |
| georgia | 32103 | 4.7% |
| illinois | 31881 | 4.6% |
| carolina | 31589 | 4.6% |
| york | 31276 | 4.5% |
| colorado | 28484 | 4.1% |
| north | 26961 | 3.9% |
| Other values (51) | 280865 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 662463 | |
| i | 552213 | 11.2% |
| o | 471160 | 9.6% |
| n | 367267 | 7.5% |
| r | 351553 | 7.1% |
| e | 300274 | 6.1% |
| s | 284743 | 5.8% |
| l | 273173 | 5.6% |
| C | 126970 | 2.6% |
| t | 120126 | 2.4% |
| Other values (37) | 1409260 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4919202 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 662463 | |
| i | 552213 | 11.2% |
| o | 471160 | 9.6% |
| n | 367267 | 7.5% |
| r | 351553 | 7.1% |
| e | 300274 | 6.1% |
| s | 284743 | 5.8% |
| l | 273173 | 5.6% |
| C | 126970 | 2.6% |
| t | 120126 | 2.4% |
| Other values (37) | 1409260 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4919202 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 662463 | |
| i | 552213 | 11.2% |
| o | 471160 | 9.6% |
| n | 367267 | 7.5% |
| r | 351553 | 7.1% |
| e | 300274 | 6.1% |
| s | 284743 | 5.8% |
| l | 273173 | 5.6% |
| C | 126970 | 2.6% |
| t | 120126 | 2.4% |
| Other values (37) | 1409260 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4919202 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 662463 | |
| i | 552213 | 11.2% |
| o | 471160 | 9.6% |
| n | 367267 | 7.5% |
| r | 351553 | 7.1% |
| e | 300274 | 6.1% |
| s | 284743 | 5.8% |
| l | 273173 | 5.6% |
| C | 126970 | 2.6% |
| t | 120126 | 2.4% |
| Other values (37) | 1409260 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.568961 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 45 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.90211 |
|---|---|
| Coefficient of variation (CV) | 0.49299289 |
| Kurtosis | -1.3034989 |
| Mean | 54.568961 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.041328217 |
| Sum | 32843202 |
| Variance | 723.7235 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91 | 65121 | 10.8% |
| 74 | 64030 | 10.6% |
| 33 | 50480 | 8.4% |
| 34 | 32103 | 5.3% |
| 41 | 31881 | 5.3% |
| 22 | 31276 | 5.2% |
| 82 | 28484 | 4.7% |
| 36 | 25540 | 4.2% |
| 38 | 20312 | 3.4% |
| 93 | 17903 | 3.0% |
| Other values (42) | 234736 |
| Value | Count | Frequency (%) |
| 1 | 4086 | 0.7% |
| 2 | 11830 | |
| 3 | 3634 | 0.6% |
| 4 | 518 | 0.1% |
| 5 | 124 | < 0.1% |
| 11 | 1776 | 0.3% |
| 12 | 1739 | 0.3% |
| 13 | 13091 | |
| 14 | 629 | 0.1% |
| 15 | 1206 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 17903 | 3.0% |
| 92 | 6843 | 1.1% |
| 91 | 65121 | |
| 88 | 966 | 0.2% |
| 87 | 10164 | 1.7% |
| 86 | 2259 | 0.4% |
| 85 | 17745 | 2.9% |
| 84 | 2816 | 0.5% |
| 83 | 2388 | 0.4% |
| 82 | 28484 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1230 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1338.6363 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 909 |
| median | 1327 |
| Q3 | 1750 |
| 95-th percentile | 2145 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 841 |
Descriptive statistics
| Standard deviation | 504.09622 |
|---|---|
| Coefficient of variation (CV) | 0.37657445 |
| Kurtosis | -1.082692 |
| Mean | 1338.6363 |
| Median Absolute Deviation (MAD) | 422 |
| Skewness | 0.077685834 |
| Sum | 8.0567966 × 108 |
| Variance | 254113 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 600 | 12248 | 2.0% |
| 700 | 8766 | 1.5% |
| 800 | 5227 | 0.9% |
| 630 | 3786 | 0.6% |
| 615 | 3621 | 0.6% |
| 900 | 3597 | 0.6% |
| 1000 | 3400 | 0.6% |
| 730 | 3343 | 0.6% |
| 830 | 3062 | 0.5% |
| 715 | 2906 | 0.5% |
| Other values (1220) | 551910 |
| Value | Count | Frequency (%) |
| 1 | 15 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 8 | 27 | |
| 9 | 2 | < 0.1% |
| 10 | 38 | |
| 11 | 4 | < 0.1% |
| 12 | 4 | < 0.1% |
| 14 | 7 | < 0.1% |
| 15 | 66 |
| Value | Count | Frequency (%) |
| 2359 | 1037 | |
| 2358 | 77 | < 0.1% |
| 2357 | 122 | < 0.1% |
| 2356 | 58 | < 0.1% |
| 2355 | 232 | < 0.1% |
| 2354 | 60 | < 0.1% |
| 2353 | 84 | < 0.1% |
| 2352 | 9 | < 0.1% |
| 2351 | 4 | < 0.1% |
| 2350 | 137 | < 0.1% |
DEP_TIME
Real number (ℝ)
MISSING 
| Distinct | 1426 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 13965 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1338.2936 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 556 |
| Q1 | 905 |
| median | 1326 |
| Q3 | 1801 |
| 95-th percentile | 2207 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 896 |
Descriptive statistics
| Standard deviation | 530.07131 |
|---|---|
| Coefficient of variation (CV) | 0.39607998 |
| Kurtosis | -0.95147354 |
| Mean | 1338.2936 |
| Median Absolute Deviation (MAD) | 431 |
| Skewness | 0.009751456 |
| Sum | 7.8678416 × 108 |
| Variance | 280975.59 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 557 | 1452 | 0.2% |
| 555 | 1400 | 0.2% |
| 558 | 1392 | 0.2% |
| 556 | 1364 | 0.2% |
| 559 | 1277 | 0.2% |
| 554 | 1204 | 0.2% |
| 600 | 1171 | 0.2% |
| 655 | 1141 | 0.2% |
| 657 | 1108 | 0.2% |
| 656 | 1020 | 0.2% |
| Other values (1416) | 575372 | |
| (Missing) | 13965 | 2.3% |
| Value | Count | Frequency (%) |
| 1 | 146 | |
| 2 | 120 | |
| 3 | 120 | |
| 4 | 107 | |
| 5 | 112 | |
| 6 | 96 | |
| 7 | 110 | |
| 8 | 99 | |
| 9 | 95 | |
| 10 | 122 |
| Value | Count | Frequency (%) |
| 2400 | 106 | |
| 2359 | 137 | |
| 2358 | 149 | |
| 2357 | 164 | |
| 2356 | 154 | |
| 2355 | 163 | |
| 2354 | 178 | |
| 2353 | 193 | |
| 2352 | 167 | |
| 2351 | 160 |
DEP_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1328 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 13979 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.250342 |
| Minimum | -46 |
|---|---|
| Maximum | 3343 |
| Zeros | 27047 |
| Zeros (%) | 4.5% |
| Negative | 282657 |
| Negative (%) | 47.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -46 |
|---|---|
| 5-th percentile | -9 |
| Q1 | -4 |
| median | 0 |
| Q3 | 20 |
| 95-th percentile | 115 |
| Maximum | 3343 |
| Range | 3389 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 70.484318 |
|---|---|
| Coefficient of variation (CV) | 3.3168557 |
| Kurtosis | 167.54493 |
| Mean | 21.250342 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 9.6895694 |
| Sum | 12492800 |
| Variance | 4968.0391 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5 | 36275 | 6.0% |
| -3 | 36157 | 6.0% |
| -4 | 35930 | 6.0% |
| -2 | 34006 | 5.7% |
| -1 | 31035 | 5.2% |
| -6 | 28676 | 4.8% |
| 0 | 27047 | 4.5% |
| -7 | 23288 | 3.9% |
| -8 | 17929 | 3.0% |
| 1 | 13189 | 2.2% |
| Other values (1318) | 304355 | |
| (Missing) | 13979 | 2.3% |
| Value | Count | Frequency (%) |
| -46 | 1 | < 0.1% |
| -41 | 2 | < 0.1% |
| -40 | 1 | < 0.1% |
| -38 | 1 | < 0.1% |
| -35 | 1 | < 0.1% |
| -33 | 2 | < 0.1% |
| -30 | 4 | < 0.1% |
| -29 | 11 | |
| -28 | 10 | |
| -27 | 15 |
| Value | Count | Frequency (%) |
| 3343 | 1 | |
| 2989 | 1 | |
| 2905 | 1 | |
| 2900 | 1 | |
| 2871 | 1 | |
| 2795 | 1 | |
| 2765 | 1 | |
| 2445 | 2 | |
| 2391 | 1 | |
| 2341 | 1 |
TAXI_OUT
Real number (ℝ)
MISSING 
| Distinct | 172 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14563 |
| Missing (%) | 2.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.521654 |
| Minimum | 1 |
|---|---|
| Maximum | 178 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 34 |
| Maximum | 178 |
| Range | 177 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 10.26939 |
|---|---|
| Coefficient of variation (CV) | 0.58609707 |
| Kurtosis | 27.621035 |
| Mean | 17.521654 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.9821154 |
| Sum | 10290520 |
| Variance | 105.46037 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13 | 48419 | 8.0% |
| 12 | 48208 | 8.0% |
| 14 | 45081 | 7.5% |
| 11 | 44848 | 7.5% |
| 15 | 40668 | 6.8% |
| 10 | 36875 | 6.1% |
| 16 | 35737 | 5.9% |
| 17 | 31098 | 5.2% |
| 18 | 26822 | 4.5% |
| 9 | 25336 | 4.2% |
| Other values (162) | 204211 |
| Value | Count | Frequency (%) |
| 1 | 9 | < 0.1% |
| 2 | 19 | < 0.1% |
| 3 | 51 | < 0.1% |
| 4 | 207 | < 0.1% |
| 5 | 604 | 0.1% |
| 6 | 2840 | 0.5% |
| 7 | 7660 | 1.3% |
| 8 | 15291 | |
| 9 | 25336 | |
| 10 | 36875 |
| Value | Count | Frequency (%) |
| 178 | 1 | < 0.1% |
| 173 | 1 | < 0.1% |
| 171 | 4 | |
| 170 | 1 | < 0.1% |
| 169 | 1 | < 0.1% |
| 168 | 1 | < 0.1% |
| 167 | 2 | < 0.1% |
| 165 | 1 | < 0.1% |
| 164 | 2 | < 0.1% |
| 163 | 7 |
TAXI_IN
Real number (ℝ)
MISSING 
| Distinct | 179 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14764 |
| Missing (%) | 2.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.4923812 |
| Minimum | 1 |
|---|---|
| Maximum | 236 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 20 |
| Maximum | 236 |
| Range | 235 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 7.6301033 |
|---|---|
| Coefficient of variation (CV) | 0.89846453 |
| Kurtosis | 61.176732 |
| Mean | 8.4923812 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.5992189 |
| Sum | 4985894 |
| Variance | 58.218476 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 85024 | |
| 4 | 84741 | |
| 6 | 70964 | |
| 7 | 57000 | |
| 3 | 47244 | |
| 8 | 43137 | |
| 9 | 33610 | 5.6% |
| 10 | 26781 | 4.4% |
| 11 | 21268 | 3.5% |
| 12 | 16496 | 2.7% |
| Other values (169) | 100837 | |
| (Missing) | 14764 | 2.5% |
| Value | Count | Frequency (%) |
| 1 | 783 | 0.1% |
| 2 | 11037 | 1.8% |
| 3 | 47244 | |
| 4 | 84741 | |
| 5 | 85024 | |
| 6 | 70964 | |
| 7 | 57000 | |
| 8 | 43137 | |
| 9 | 33610 | 5.6% |
| 10 | 26781 | 4.4% |
| Value | Count | Frequency (%) |
| 236 | 1 | |
| 233 | 1 | |
| 221 | 1 | |
| 198 | 1 | |
| 197 | 1 | |
| 196 | 1 | |
| 190 | 1 | |
| 189 | 1 | |
| 188 | 2 | |
| 185 | 1 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1306 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1476.4951 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 656 |
| Q1 | 1048 |
| median | 1509 |
| Q3 | 1926 |
| 95-th percentile | 2301 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 878 |
Descriptive statistics
| Standard deviation | 539.00035 |
|---|---|
| Coefficient of variation (CV) | 0.36505394 |
| Kurtosis | -0.47111061 |
| Mean | 1476.4951 |
| Median Absolute Deviation (MAD) | 427 |
| Skewness | -0.31967633 |
| Sum | 8.886522 × 108 |
| Variance | 290521.38 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2359 | 3051 | 0.5% |
| 1900 | 1910 | 0.3% |
| 2100 | 1875 | 0.3% |
| 1810 | 1775 | 0.3% |
| 1855 | 1773 | 0.3% |
| 1915 | 1748 | 0.3% |
| 2145 | 1736 | 0.3% |
| 2000 | 1730 | 0.3% |
| 1140 | 1706 | 0.3% |
| 905 | 1672 | 0.3% |
| Other values (1296) | 582890 |
| Value | Count | Frequency (%) |
| 1 | 79 | < 0.1% |
| 2 | 161 | < 0.1% |
| 3 | 282 | < 0.1% |
| 4 | 155 | < 0.1% |
| 5 | 755 | |
| 6 | 77 | < 0.1% |
| 7 | 56 | < 0.1% |
| 8 | 75 | < 0.1% |
| 9 | 128 | < 0.1% |
| 10 | 601 |
| Value | Count | Frequency (%) |
| 2359 | 3051 | |
| 2358 | 819 | 0.1% |
| 2357 | 713 | 0.1% |
| 2356 | 564 | 0.1% |
| 2355 | 1289 | |
| 2354 | 508 | 0.1% |
| 2353 | 564 | 0.1% |
| 2352 | 600 | 0.1% |
| 2351 | 287 | < 0.1% |
| 2350 | 958 | 0.2% |
ARR_TIME
Real number (ℝ)
MISSING 
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 14764 |
| Missing (%) | 2.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1427.2859 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 259 |
| Q1 | 1018 |
| median | 1441 |
| Q3 | 1916 |
| 95-th percentile | 2257 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 898 |
Descriptive statistics
| Standard deviation | 579.08175 |
|---|---|
| Coefficient of variation (CV) | 0.40572232 |
| Kurtosis | -0.42709795 |
| Mean | 1427.2859 |
| Median Absolute Deviation (MAD) | 440 |
| Skewness | -0.3953112 |
| Sum | 8.379624 × 108 |
| Variance | 335335.67 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1136 | 673 | 0.1% |
| 2132 | 652 | 0.1% |
| 1146 | 636 | 0.1% |
| 1121 | 634 | 0.1% |
| 1645 | 631 | 0.1% |
| 1138 | 630 | 0.1% |
| 1135 | 628 | 0.1% |
| 1137 | 627 | 0.1% |
| 1227 | 626 | 0.1% |
| 1856 | 624 | 0.1% |
| Other values (1430) | 580741 | |
| (Missing) | 14764 | 2.5% |
| Value | Count | Frequency (%) |
| 1 | 457 | |
| 2 | 453 | |
| 3 | 406 | |
| 4 | 411 | |
| 5 | 409 | |
| 6 | 411 | |
| 7 | 397 | |
| 8 | 420 | |
| 9 | 351 | |
| 10 | 371 |
| Value | Count | Frequency (%) |
| 2400 | 386 | |
| 2359 | 404 | |
| 2358 | 438 | |
| 2357 | 466 | |
| 2356 | 491 | |
| 2355 | 444 | |
| 2354 | 499 | |
| 2353 | 472 | |
| 2352 | 448 | |
| 2351 | 519 |
ARR_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1358 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 16808 |
| Missing (%) | 2.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.641825 |
| Minimum | -86 |
|---|---|
| Maximum | 3337 |
| Zeros | 10416 |
| Zeros (%) | 1.7% |
| Negative | 312657 |
| Negative (%) | 51.9% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | -86 |
|---|---|
| 5-th percentile | -24 |
| Q1 | -13 |
| median | -2 |
| Q3 | 20 |
| 95-th percentile | 116 |
| Maximum | 3337 |
| Range | 3423 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 72.101824 |
|---|---|
| Coefficient of variation (CV) | 4.3325671 |
| Kurtosis | 152.87673 |
| Mean | 16.641825 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 9.0734374 |
| Sum | 9736433 |
| Variance | 5198.673 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -10 | 15439 | 2.6% |
| -11 | 15407 | 2.6% |
| -9 | 15156 | 2.5% |
| -12 | 15027 | 2.5% |
| -8 | 14946 | 2.5% |
| -7 | 14693 | 2.4% |
| -13 | 14628 | 2.4% |
| -6 | 14129 | 2.3% |
| -14 | 14046 | 2.3% |
| -15 | 13315 | 2.2% |
| Other values (1348) | 438272 | |
| (Missing) | 16808 | 2.8% |
| Value | Count | Frequency (%) |
| -86 | 1 | < 0.1% |
| -85 | 1 | < 0.1% |
| -74 | 1 | < 0.1% |
| -73 | 2 | |
| -72 | 1 | < 0.1% |
| -71 | 1 | < 0.1% |
| -69 | 1 | < 0.1% |
| -68 | 2 | |
| -66 | 3 | |
| -65 | 2 |
| Value | Count | Frequency (%) |
| 3337 | 1 | |
| 2980 | 1 | |
| 2912 | 1 | |
| 2891 | 1 | |
| 2854 | 1 | |
| 2786 | 1 | |
| 2748 | 1 | |
| 2429 | 1 | |
| 2424 | 1 | |
| 2418 | 1 |
CANCELLED
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 14606 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1805598 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 587260 | |
| 1.0 | 14606 | 2.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 587260 | |
| 1.0 | 14606 | 2.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1189126 | |
| . | 601866 | |
| 1 | 14606 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1189126 | |
| . | 601866 | |
| 1 | 14606 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1189126 | |
| . | 601866 | |
| 1 | 14606 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1189126 | |
| . | 601866 | |
| 1 | 14606 | 0.8% |
CANCELLATION_CODE
Categorical
MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 587260 |
| Missing (%) | 97.6% |
| Memory size | 4.6 MiB |
| B | |
|---|---|
| A | |
| C |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 14606 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | C |
| 5th row | C |
Common Values
| Value | Count | Frequency (%) |
| B | 6863 | 1.1% |
| A | 4013 | 0.7% |
| C | 3730 | 0.6% |
| (Missing) | 587260 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 6863 | |
| a | 4013 | |
| c | 3730 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 6863 | |
| A | 4013 | |
| C | 3730 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14606 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 6863 | |
| A | 4013 | |
| C | 3730 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14606 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 6863 | |
| A | 4013 | |
| C | 3730 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14606 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 6863 | |
| A | 4013 | |
| C | 3730 |
DIVERTED
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 2202 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1805598 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 599664 | |
| 1.0 | 2202 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 599664 | |
| 1.0 | 2202 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1201530 | |
| . | 601866 | |
| 1 | 2202 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1201530 | |
| . | 601866 | |
| 1 | 2202 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1201530 | |
| . | 601866 | |
| 1 | 2202 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1805598 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1201530 | |
| . | 601866 | |
| 1 | 2202 | 0.1% |
AIR_TIME
Real number (ℝ)
MISSING 
| Distinct | 602 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 16808 |
| Missing (%) | 2.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 115.15852 |
| Minimum | 8 |
|---|---|
| Maximum | 671 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 63 |
| median | 98 |
| Q3 | 145 |
| 95-th percentile | 272 |
| Maximum | 671 |
| Range | 663 |
| Interquartile range (IQR) | 82 |
Descriptive statistics
| Standard deviation | 70.952552 |
|---|---|
| Coefficient of variation (CV) | 0.61612939 |
| Kurtosis | 2.1090581 |
| Mean | 115.15852 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 1.3573678 |
| Sum | 67374416 |
| Variance | 5034.2646 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 63 | 5037 | 0.8% |
| 64 | 4865 | 0.8% |
| 65 | 4819 | 0.8% |
| 62 | 4803 | 0.8% |
| 61 | 4782 | 0.8% |
| 66 | 4747 | 0.8% |
| 60 | 4736 | 0.8% |
| 54 | 4715 | 0.8% |
| 67 | 4677 | 0.8% |
| 59 | 4672 | 0.8% |
| Other values (592) | 537205 | |
| (Missing) | 16808 | 2.8% |
| Value | Count | Frequency (%) |
| 8 | 4 | < 0.1% |
| 9 | 18 | < 0.1% |
| 10 | 21 | < 0.1% |
| 11 | 9 | < 0.1% |
| 12 | 3 | < 0.1% |
| 13 | 22 | < 0.1% |
| 14 | 25 | < 0.1% |
| 15 | 41 | < 0.1% |
| 16 | 103 | |
| 17 | 234 |
| Value | Count | Frequency (%) |
| 671 | 1 | < 0.1% |
| 654 | 1 | < 0.1% |
| 653 | 1 | < 0.1% |
| 652 | 2 | |
| 651 | 1 | < 0.1% |
| 648 | 1 | < 0.1% |
| 647 | 2 | |
| 646 | 1 | < 0.1% |
| 641 | 1 | < 0.1% |
| 640 | 3 |
CARRIER_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1058 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 434786 |
| Missing (%) | 72.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.42749 |
| Minimum | 0 |
|---|---|
| Maximum | 3337 |
| Zeros | 70641 |
| Zeros (%) | 11.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 23 |
| 95-th percentile | 108 |
| Maximum | 3337 |
| Range | 3337 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 81.568453 |
|---|---|
| Coefficient of variation (CV) | 3.0865002 |
| Kurtosis | 177.96967 |
| Mean | 26.42749 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 10.560613 |
| Sum | 4415505 |
| Variance | 6653.4125 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 70641 | 11.7% |
| 2 | 3291 | 0.5% |
| 1 | 3217 | 0.5% |
| 6 | 3082 | 0.5% |
| 3 | 3027 | 0.5% |
| 4 | 2981 | 0.5% |
| 7 | 2876 | 0.5% |
| 5 | 2867 | 0.5% |
| 15 | 2689 | 0.4% |
| 8 | 2599 | 0.4% |
| Other values (1048) | 69810 | 11.6% |
| (Missing) | 434786 |
| Value | Count | Frequency (%) |
| 0 | 70641 | |
| 1 | 3217 | 0.5% |
| 2 | 3291 | 0.5% |
| 3 | 3027 | 0.5% |
| 4 | 2981 | 0.5% |
| 5 | 2867 | 0.5% |
| 6 | 3082 | 0.5% |
| 7 | 2876 | 0.5% |
| 8 | 2599 | 0.4% |
| 9 | 2522 | 0.4% |
| Value | Count | Frequency (%) |
| 3337 | 1 | |
| 2980 | 1 | |
| 2891 | 1 | |
| 2693 | 1 | |
| 2635 | 1 | |
| 2429 | 1 | |
| 2388 | 1 | |
| 2328 | 1 | |
| 2279 | 1 | |
| 2275 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 477 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 434786 |
| Missing (%) | 72.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.5310749 |
| Minimum | 0 |
|---|---|
| Maximum | 1380 |
| Zeros | 155236 |
| Zeros (%) | 25.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 20 |
| Maximum | 1380 |
| Range | 1380 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 30.838416 |
|---|---|
| Coefficient of variation (CV) | 6.8059824 |
| Kurtosis | 507.10369 |
| Mean | 4.5310749 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.191266 |
| Sum | 757052 |
| Variance | 951.00792 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 155236 | 25.8% |
| 15 | 235 | < 0.1% |
| 20 | 210 | < 0.1% |
| 16 | 206 | < 0.1% |
| 18 | 196 | < 0.1% |
| 6 | 196 | < 0.1% |
| 17 | 196 | < 0.1% |
| 7 | 192 | < 0.1% |
| 10 | 188 | < 0.1% |
| 19 | 188 | < 0.1% |
| Other values (467) | 10037 | 1.7% |
| (Missing) | 434786 |
| Value | Count | Frequency (%) |
| 0 | 155236 | |
| 1 | 172 | < 0.1% |
| 2 | 175 | < 0.1% |
| 3 | 172 | < 0.1% |
| 4 | 164 | < 0.1% |
| 5 | 162 | < 0.1% |
| 6 | 196 | < 0.1% |
| 7 | 192 | < 0.1% |
| 8 | 178 | < 0.1% |
| 9 | 158 | < 0.1% |
| Value | Count | Frequency (%) |
| 1380 | 1 | |
| 1312 | 1 | |
| 1281 | 1 | |
| 1269 | 1 | |
| 1266 | 1 | |
| 1238 | 1 | |
| 1236 | 1 | |
| 1151 | 1 | |
| 1124 | 1 | |
| 1118 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 506 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 434786 |
| Missing (%) | 72.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.0079 |
| Minimum | 0 |
|---|---|
| Maximum | 1651 |
| Zeros | 90483 |
| Zeros (%) | 15.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 16 |
| 95-th percentile | 64 |
| Maximum | 1651 |
| Range | 1651 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 37.36045 |
|---|---|
| Coefficient of variation (CV) | 2.6670985 |
| Kurtosis | 220.03042 |
| Mean | 14.0079 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.484565 |
| Sum | 2340440 |
| Variance | 1395.8033 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 90483 | 15.0% |
| 1 | 4205 | 0.7% |
| 2 | 3061 | 0.5% |
| 3 | 2973 | 0.5% |
| 4 | 2688 | 0.4% |
| 5 | 2550 | 0.4% |
| 15 | 2397 | 0.4% |
| 6 | 2351 | 0.4% |
| 7 | 2205 | 0.4% |
| 16 | 2121 | 0.4% |
| Other values (496) | 52046 | 8.6% |
| (Missing) | 434786 |
| Value | Count | Frequency (%) |
| 0 | 90483 | |
| 1 | 4205 | 0.7% |
| 2 | 3061 | 0.5% |
| 3 | 2973 | 0.5% |
| 4 | 2688 | 0.4% |
| 5 | 2550 | 0.4% |
| 6 | 2351 | 0.4% |
| 7 | 2205 | 0.4% |
| 8 | 2039 | 0.3% |
| 9 | 2025 | 0.3% |
| Value | Count | Frequency (%) |
| 1651 | 1 | |
| 1256 | 1 | |
| 1253 | 1 | |
| 1223 | 1 | |
| 1198 | 1 | |
| 1184 | 1 | |
| 1172 | 1 | |
| 1154 | 1 | |
| 1144 | 1 | |
| 1140 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 91 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 434786 |
| Missing (%) | 72.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10955231 |
| Minimum | 0 |
|---|---|
| Maximum | 581 |
| Zeros | 166287 |
| Zeros (%) | 27.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 581 |
| Range | 581 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.6644116 |
|---|---|
| Coefficient of variation (CV) | 24.320908 |
| Kurtosis | 14777.571 |
| Mean | 0.10955231 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 86.503517 |
| Sum | 18304 |
| Variance | 7.0990894 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 166287 | 27.6% |
| 7 | 32 | < 0.1% |
| 13 | 31 | < 0.1% |
| 6 | 31 | < 0.1% |
| 18 | 29 | < 0.1% |
| 5 | 28 | < 0.1% |
| 4 | 26 | < 0.1% |
| 2 | 25 | < 0.1% |
| 10 | 25 | < 0.1% |
| 19 | 25 | < 0.1% |
| Other values (81) | 541 | 0.1% |
| (Missing) | 434786 |
| Value | Count | Frequency (%) |
| 0 | 166287 | |
| 1 | 23 | < 0.1% |
| 2 | 25 | < 0.1% |
| 3 | 21 | < 0.1% |
| 4 | 26 | < 0.1% |
| 5 | 28 | < 0.1% |
| 6 | 31 | < 0.1% |
| 7 | 32 | < 0.1% |
| 8 | 23 | < 0.1% |
| 9 | 24 | < 0.1% |
| Value | Count | Frequency (%) |
| 581 | 1 | |
| 241 | 1 | |
| 200 | 1 | |
| 156 | 1 | |
| 152 | 1 | |
| 139 | 1 | |
| 137 | 1 | |
| 135 | 2 | |
| 133 | 1 | |
| 128 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 871 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 434786 |
| Missing (%) | 72.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.519302 |
| Minimum | 0 |
|---|---|
| Maximum | 2557 |
| Zeros | 72648 |
| Zeros (%) | 12.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 9 |
| Q3 | 40 |
| 95-th percentile | 141 |
| Maximum | 2557 |
| Range | 2557 |
| Interquartile range (IQR) | 40 |
Descriptive statistics
| Standard deviation | 70.855023 |
|---|---|
| Coefficient of variation (CV) | 2.1138573 |
| Kurtosis | 102.44716 |
| Mean | 33.519302 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 7.4326583 |
| Sum | 5600405 |
| Variance | 5020.4342 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 72648 | 12.1% |
| 15 | 2023 | 0.3% |
| 16 | 1930 | 0.3% |
| 17 | 1864 | 0.3% |
| 18 | 1846 | 0.3% |
| 19 | 1767 | 0.3% |
| 20 | 1731 | 0.3% |
| 21 | 1604 | 0.3% |
| 22 | 1601 | 0.3% |
| 14 | 1530 | 0.3% |
| Other values (861) | 78536 | 13.0% |
| (Missing) | 434786 |
| Value | Count | Frequency (%) |
| 0 | 72648 | |
| 1 | 1121 | 0.2% |
| 2 | 1162 | 0.2% |
| 3 | 1203 | 0.2% |
| 4 | 1147 | 0.2% |
| 5 | 1146 | 0.2% |
| 6 | 1249 | 0.2% |
| 7 | 1217 | 0.2% |
| 8 | 1349 | 0.2% |
| 9 | 1448 | 0.2% |
| Value | Count | Frequency (%) |
| 2557 | 1 | |
| 2032 | 1 | |
| 2011 | 1 | |
| 1919 | 1 | |
| 1833 | 1 | |
| 1745 | 1 | |
| 1669 | 1 | |
| 1661 | 1 | |
| 1627 | 1 | |
| 1623 | 1 |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 7/3/2023 12:00:00 AM | 9E | 4901 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 12478 | JFK | New York, NY | New York | 22 | 1942 | 2016.0 | 34.0 | 37.0 | 55.0 | 2200 | 2342.0 | 102.0 | 0.0 | NaN | 0.0 | 114.0 | 0.0 | 0.0 | 68.0 | 0.0 | 34.0 |
| 1 | 1 | 7/3/2023 12:00:00 AM | 9E | 4901 | 12478 | JFK | New York, NY | New York | 22 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 1626 | 1733.0 | 67.0 | 40.0 | 7.0 | 1850 | 1946.0 | 56.0 | 0.0 | NaN | 0.0 | 86.0 | 56.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2 | 1 | 7/3/2023 12:00:00 AM | 9E | 4902 | 15096 | SYR | Syracuse, NY | New York | 22 | 11433 | DTW | Detroit, MI | Michigan | 43 | 610 | 958.0 | 228.0 | 15.0 | 10.0 | 739 | 1121.0 | 222.0 | 0.0 | NaN | 0.0 | 58.0 | 222.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3 | 1 | 7/3/2023 12:00:00 AM | 9E | 4904 | 10581 | BGR | Bangor, ME | Maine | 12 | 12953 | LGA | New York, NY | New York | 22 | 1218 | 1215.0 | -3.0 | 7.0 | 7.0 | 1359 | 1332.0 | -27.0 | 0.0 | NaN | 0.0 | 63.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 7/3/2023 12:00:00 AM | 9E | 4904 | 12953 | LGA | New York, NY | New York | 22 | 10581 | BGR | Bangor, ME | Maine | 12 | 945 | 943.0 | -2.0 | 19.0 | 5.0 | 1133 | 1102.0 | -31.0 | 0.0 | NaN | 0.0 | 55.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 7/3/2023 12:00:00 AM | 9E | 4905 | 12953 | LGA | New York, NY | New York | 22 | 11267 | DAY | Dayton, OH | Ohio | 44 | 1030 | 1024.0 | -6.0 | 15.0 | 3.0 | 1239 | 1203.0 | -36.0 | 0.0 | NaN | 0.0 | 81.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 7/3/2023 12:00:00 AM | 9E | 4906 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 13377 | MLU | Monroe, LA | Louisiana | 72 | 1010 | 1005.0 | -5.0 | 22.0 | 3.0 | 1048 | 1036.0 | -12.0 | 0.0 | NaN | 0.0 | 66.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 7/3/2023 12:00:00 AM | 9E | 4906 | 13377 | MLU | Monroe, LA | Louisiana | 72 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 1133 | 1139.0 | 6.0 | 27.0 | 7.0 | 1419 | 1419.0 | 0.0 | 0.0 | NaN | 0.0 | 66.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 7/3/2023 12:00:00 AM | 9E | 4907 | 10581 | BGR | Bangor, ME | Maine | 12 | 12478 | JFK | New York, NY | New York | 22 | 1919 | 1910.0 | -9.0 | 11.0 | 17.0 | 2100 | 2046.0 | -14.0 | 0.0 | NaN | 0.0 | 68.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 1 | 7/3/2023 12:00:00 AM | 9E | 4911 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 11150 | CSG | Columbus, GA | Georgia | 34 | 1204 | 1206.0 | 2.0 | 11.0 | 4.0 | 1251 | 1241.0 | -10.0 | 0.0 | NaN | 0.0 | 20.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601856 | 7 | 7/30/2023 12:00:00 AM | YX | 5832 | 12953 | LGA | New York, NY | New York | 22 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 1051 | 1105.0 | 14.0 | 16.0 | 10.0 | 1318 | 1314.0 | -4.0 | 0.0 | NaN | 0.0 | 103.0 | NaN | NaN | NaN | NaN | NaN |
| 601857 | 7 | 7/30/2023 12:00:00 AM | YX | 5833 | 12478 | JFK | New York, NY | New York | 22 | 11066 | CMH | Columbus, OH | Ohio | 44 | 2130 | 2125.0 | -5.0 | 29.0 | 12.0 | 2339 | 2327.0 | -12.0 | 0.0 | NaN | 0.0 | 81.0 | NaN | NaN | NaN | NaN | NaN |
| 601858 | 7 | 7/30/2023 12:00:00 AM | YX | 5834 | 12953 | LGA | New York, NY | New York | 22 | 13485 | MSN | Madison, WI | Wisconsin | 45 | 2050 | 2144.0 | 54.0 | 20.0 | 4.0 | 2225 | 2311.0 | 46.0 | 0.0 | NaN | 0.0 | 123.0 | 46.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 601859 | 7 | 7/30/2023 12:00:00 AM | YX | 5838 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1700 | 1659.0 | -1.0 | 14.0 | 20.0 | 1936 | 1918.0 | -18.0 | 0.0 | NaN | 0.0 | 105.0 | NaN | NaN | NaN | NaN | NaN |
| 601860 | 7 | 7/30/2023 12:00:00 AM | YX | 5839 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11066 | CMH | Columbus, OH | Ohio | 44 | 1330 | 1326.0 | -4.0 | 54.0 | 5.0 | 1545 | 1607.0 | 22.0 | 0.0 | NaN | 0.0 | 102.0 | 0.0 | 0.0 | 22.0 | 0.0 | 0.0 |
| 601861 | 7 | 7/30/2023 12:00:00 AM | YX | 5840 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 800 | 755.0 | -5.0 | 26.0 | 22.0 | 1015 | 1018.0 | 3.0 | 0.0 | NaN | 0.0 | 95.0 | NaN | NaN | NaN | NaN | NaN |
| 601862 | 7 | 7/30/2023 12:00:00 AM | YX | 5840 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1100 | 1053.0 | -7.0 | 15.0 | 13.0 | 1248 | 1233.0 | -15.0 | 0.0 | NaN | 0.0 | 72.0 | NaN | NaN | NaN | NaN | NaN |
| 601863 | 7 | 7/30/2023 12:00:00 AM | YX | 5844 | 12953 | LGA | New York, NY | New York | 22 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1000 | 1026.0 | 26.0 | 21.0 | 10.0 | 1136 | 1133.0 | -3.0 | 0.0 | NaN | 0.0 | 36.0 | NaN | NaN | NaN | NaN | NaN |
| 601864 | 7 | 7/30/2023 12:00:00 AM | YX | 5845 | 10154 | ACK | Nantucket, MA | Massachusetts | 13 | 12478 | JFK | New York, NY | New York | 22 | 1152 | 1149.0 | -3.0 | 10.0 | 6.0 | 1309 | 1253.0 | -16.0 | 0.0 | NaN | 0.0 | 48.0 | NaN | NaN | NaN | NaN | NaN |
| 601865 | 7 | 7/30/2023 12:00:00 AM | YX | 5846 | 11066 | CMH | Columbus, OH | Ohio | 44 | 12478 | JFK | New York, NY | New York | 22 | 1145 | 1138.0 | -7.0 | 18.0 | 12.0 | 1359 | 1335.0 | -24.0 | 0.0 | NaN | 0.0 | 87.0 | NaN | NaN | NaN | NaN | NaN |